<report xmlns="http://developer.cognos.com/schemas/report/12.0/" expressionLocale="en-us" useStyleVersion="10" interactivePageBreakByFrame="true"><!--RSU-SPC-0093 The report specification was upgraded from "http://developer.cognos.com/schemas/report/11.0/" to "http://developer.cognos.com/schemas/report/12.0/" at 2016-3-30. 16:23:32-->
				<modelPath>/content/folder[@name='Packages']/package[@name='Storage and Storage Pool Capacity']/model[@name='model']</modelPath>
				<drillBehavior modelBasedDrillThru="true"/>
				
				<layouts>
					<layout>
						<reportPages>
							<page name="Page1"><style><defaultStyles><defaultStyle refStyle="pg"/></defaultStyles></style>
								<pageBody><style><defaultStyles><defaultStyle refStyle="pb"/></defaultStyles></style>
									<contents>
										
									<HTMLItem>
			<dataSource>
				<staticValue>&lt;style&gt; #headerBack { display: none; } .mainHeader1 { display: none; } .mainViewerHeader3 { display: none; } &lt;/style&gt;</staticValue>
			</dataSource>
		</HTMLItem><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;width:100%"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Powered by OnCommand Insight</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:18px;font-weight:bold;color:white"/></style></textItem></contents><style><CSS value="height:24px;padding-left:24px;background-color:#6198C5"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>QoS Policy and Status</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:24px;color:#333333"/></style></textItem></contents><style><CSS value="height:36px;background-color:#FBFBFB;padding-left:24px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/><style><CSS value="border:1px solid #E1E1E2"/></style></tableCell></tableCells></tableRow></tableRows></table><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse;margin-top:10px"/></style><tableRows><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Summary and Detail</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14pt;color:gray"/></style></textItem></contents><style><CSS value="background-color:#EBECEC;padding-top:2px;padding-bottom:2px;padding-left:15px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents>
																		<v2_combinationChart maxHotspots="10000" orientation="horizontal" name="Combination Chart1" refQuery="Top Utilized Volumes">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							<CSS value="color:#555555"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Volume"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="% Available"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_bar>
																							<v2_solidPalette>
																								<v2_solidPaletteEntries><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#6198C5" transparency="10"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#E5B09E" transparency="10"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#99CCFF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor color="#0084e3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#99AACC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#999999"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																							<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="QoS Limit IOPS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_bar>
																					</v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange>
																							<v2_automaticRange/>
																						</v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																							</style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:900px;height:300px;border:1pt solid silver"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					</style>
																				</v2_legend>
																				<v2_chartTitle refQuery="Top Utilized Volumes"><style><defaultStyles><defaultStyle refStyle="ct"/></defaultStyles><CSS value="color:gray;font-size:10pt"/></style><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>Top QoS Volume Utilization</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems></v2_chartTitle></v2_combinationChart></contents></tableCell><tableCell><contents/></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-top:15px;padding-bottom:10px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><block>
			<contents><list name="List2" refQuery="QoS Policies" pageBreakText="false">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;table-layout:fixed"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles><CSS value="width:200px"/></style><contents><textItem><dataSource><dataItemLabel refDataItem="Volume"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;width:200px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Volume"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Allocated GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Allocated GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Used GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="QoS Policy"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="QoS Policy"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="QoS Limit IOPS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="QoS Limit IOPS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total IOpS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Total IOpS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak IOpS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak IOpS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="IOpS/TB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="IOpS/TB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="% Available"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><percentFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="% Available"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns></list></contents>
		<style><CSS value="width:900px;height:39px;overflow:hidden"/></style></block></contents></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><block>
			<contents><list horizontalPagination="true" name="List1" refQuery="QoS Policies" showColumnTitles="hide" rowsPerPage="100">
			
			
			
			<noDataHandler>
				<contents>
					<block>
						<contents>
							<textItem>
								<dataSource>
									<staticValue>No Data Available</staticValue>
								</dataSource>
								<style>
									<CSS value="padding:10px 18px;"/>
								</style>
							</textItem>
						</contents>
					</block>
				</contents>
			</noDataHandler>
			<style>
				<CSS value="border-collapse:collapse;width:100%;table-layout:fixed"/>
				<defaultStyles>
					<defaultStyle refStyle="ls"/>
				</defaultStyles>
			</style>
		<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Storage Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Volume"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left;width:200px"/></style><contents><textItem><dataSource><dataItemValue refDataItem="Volume"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Allocated GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Allocated GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Used GB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/><dataFormat><numberFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="Used GB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="QoS Policy"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="text-align:left"/></style><contents><textItem><dataSource><dataItemValue refDataItem="QoS Policy"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="QoS Limit IOPS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="QoS Limit IOPS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Total IOpS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Total IOpS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Peak IOpS"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Peak IOpS"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="IOpS/TB"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="IOpS/TB"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="% Available"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><percentFormat decimalSize="2"/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="% Available"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><sortList><sortItem refDataItem="% Available" sortOrder="ascending"/></sortList></list></contents>
		<style><CSS value="width:916px;height:425px;overflow:auto;border-bottom:1pt solid silver"/></style></block></contents></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="vertical-align:top"/></style></tableCell><tableCell><contents><table><style><defaultStyles><defaultStyle refStyle="tb"/></defaultStyles><CSS value="border-collapse:collapse"/></style><tableRows><tableRow><tableCells><tableCell><contents><textItem><dataSource><staticValue>Most Active by Policy</staticValue></dataSource><style><CSS value="font-family:Arial;font-size:14pt;color:gray"/></style></textItem></contents><style><CSS value="background-color:#EBECEC;padding-top:2px;padding-bottom:2px;padding-left:15px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart2" refQuery="Top Extreme">
																				<v2_combinationTypeTooltips/>
																				<v2_commonAxis>
																					<v2_ordinalAxis>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																								<CSS value="font-size:8pt;color:#555555"/></style>
																						</v2_axisLabels>
																					</v2_ordinalAxis>
																					<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Volume"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="% Available"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
																				<v2_topLeftAxis>
																					<v2_combinationChartTypes>
																						<v2_bar>
																							<v2_solidPalette>
																								<v2_solidPaletteEntries><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#6198C5" transparency="10"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#E5B09E" transparency="10"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#99CCFF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor color="#0084e3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#99AACC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#999999"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
																							<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="QoS Limit IOPS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat decimalSize="0"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat decimalSize="0"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
																					</v2_combinationChartTypes>
																					<v2_axis>
																						<v2_axisRange scale="log">
																							<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
																						</v2_axisRange>
																						<v2_axisLabels>
																							<style>
																								<defaultStyles>
																									<defaultStyle refStyle="al"/>
																								</defaultStyles>
																								<CSS value="font-size:8pt"/><dataFormat><numberFormat pattern="###,###' IOs'"/></dataFormat></style>
																						</v2_axisLabels>
																						<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
																					</v2_axis>
																				</v2_topLeftAxis>
																				<style>
																					<defaultStyles>
																						<defaultStyle refStyle="ch"/>
																					</defaultStyles>
																					<CSS value="width:500px;height:255px;border:1pt solid silver"/></style>
																				<noDataHandler>
																					<contents>
																						<block>
																							<contents>
																								<textItem>
																									<dataSource>
																										<staticValue>No Data Available</staticValue>
																									</dataSource>
																									<style>
																										<CSS value="padding:10px 18px;"/>
																									</style>
																								</textItem>
																							</contents>
																						</block>
																					</contents>
																				</noDataHandler>
																				<v2_legend>
																					<v2_legendPosition>
																						<v2_legendPreset legendPositionPreset="bottom"/>
																					</v2_legendPosition>
																					<style>
																						<defaultStyles>
																							<defaultStyle refStyle="lg"/>
																						</defaultStyles>
																					</style>
																				</v2_legend>
																				<v2_chartTitle refQuery="Top Extreme"><style><defaultStyles><defaultStyle refStyle="ct"/></defaultStyles><CSS value="text-align:left;color:gray;font-size:10pt"/></style><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>Top Extreme Volumes</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems></v2_chartTitle></v2_combinationChart>
																		</contents><style><CSS value="padding-top:15px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart3" refQuery="Top High Write">
	<v2_combinationTypeTooltips/>
	<v2_commonAxis>
		<v2_ordinalAxis>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
					<CSS value="font-size:8pt;color:#555555"/></style>
			</v2_axisLabels>
		</v2_ordinalAxis>
		<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Volume"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="% Available"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
	<v2_topLeftAxis>
		<v2_combinationChartTypes>
			<v2_bar>
				<v2_solidPalette>
					<v2_solidPaletteEntries><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#6198C5" transparency="10"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#E5B09E" transparency="10"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#99CCFF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor color="#0084e3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#99AACC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#999999"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
				<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="QoS Limit IOPS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat decimalSize="0"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat decimalSize="0"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
		</v2_combinationChartTypes>
		<v2_axis>
			<v2_axisRange scale="log">
				<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
			</v2_axisRange>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
					<CSS value="font-size:8pt"/><dataFormat><numberFormat pattern="###,###' IOs'"/></dataFormat></style>
			</v2_axisLabels>
			<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
		</v2_axis>
	</v2_topLeftAxis>
	<style>
		<defaultStyles>
			<defaultStyle refStyle="ch"/>
		</defaultStyles>
		<CSS value="width:500px;height:255px;border:1pt solid silver"/></style>
	<noDataHandler>
		<contents>
			<block>
				<contents>
					<textItem>
						<dataSource>
							<staticValue>No Data Available</staticValue>
						</dataSource>
						<style>
							<CSS value="padding:10px 18px;"/>
						</style>
					</textItem>
				</contents>
			</block>
		</contents>
	</noDataHandler>
	<v2_legend>
		<v2_legendPosition>
			<v2_legendPreset legendPositionPreset="bottom"/>
		</v2_legendPosition>
		<style>
			<defaultStyles>
				<defaultStyle refStyle="lg"/>
			</defaultStyles>
		</style>
	</v2_legend>
	<v2_chartTitle refQuery="Top High Write"><style><defaultStyles><defaultStyle refStyle="ct"/></defaultStyles><CSS value="text-align:left;color:gray;font-size:10pt"/></style><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>Top High Write Volumes</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems></v2_chartTitle></v2_combinationChart></contents><style><CSS value="padding-top:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents><v2_combinationChart maxHotspots="10000" name="Combination Chart4" refQuery="Top Performance">
	<v2_combinationTypeTooltips/>
	<v2_commonAxis>
		<v2_ordinalAxis>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
					<CSS value="font-size:8pt;color:#555555"/></style>
			</v2_axisLabels>
		</v2_ordinalAxis>
		<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="Volume"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><sortList><sortItem refDataItem="% Available"/></sortList></chartNodeMember></chartNodeMembers></chartNode></chartNodes></v2_commonAxis>
	<v2_topLeftAxis>
		<v2_combinationChartTypes>
			<v2_bar>
				<v2_solidPalette>
					<v2_solidPaletteEntries><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#336699">
																											<v2_solidColor color="#6198C5" transparency="10"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#000066">
																											<v2_solidColor color="#E5B09E" transparency="10"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#99CCFF">
																											<v2_solidColor color="#99CCFF"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#F3F3F3">
																											<v2_solidColor color="#F3F3F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#0084e3">
																											<v2_solidColor color="#0084e3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#E7E7E7">
																											<v2_solidColor color="#E7E7E7"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#99AACC">
																											<v2_solidColor color="#99AACC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#999999">
																											<v2_solidColor color="#999999"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#E3E9F3">
																											<v2_solidColor color="#E3E9F3"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry><v2_solidPaletteEntry>
																										<v2_fillEffect defaultColor="#CCCCCC">
																											<v2_solidColor color="#CCCCCC"/>
																										</v2_fillEffect>
																									</v2_solidPaletteEntry></v2_solidPaletteEntries></v2_solidPalette>
				<chartNodes><chartNode><chartNodeMembers><chartNodeMember refDataItem="QoS Limit IOPS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat decimalSize="0"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode><chartNode><chartNodeMembers><chartNodeMember refDataItem="Total IOpS"><chartContents><chartTextItem><dataSource><memberCaption/></dataSource></chartTextItem></chartContents><style><dataFormat><numberFormat decimalSize="0"/></dataFormat></style></chartNodeMember></chartNodeMembers></chartNode></chartNodes><v2_chartDataLabels displayDataLocation="outsideAtTop" labelCollisionMode="fine_stagger" leaderLines="hide" labelValueType="absolute"/></v2_bar>
		</v2_combinationChartTypes>
		<v2_axis>
			<v2_axisRange scale="log">
				<v2_automaticRange sameRangeAllInstances="true" includeZeroForAutoScale="true"/>
			</v2_axisRange>
			<v2_axisLabels>
				<style>
					<defaultStyles>
						<defaultStyle refStyle="al"/>
					</defaultStyles>
					<CSS value="font-size:8pt"/><dataFormat><numberFormat pattern="###,###' IOs'"/></dataFormat></style>
			</v2_axisLabels>
			<v2_majorGridlines lineColor="#CCCCCC" lineWeight="0"/>
		</v2_axis>
	</v2_topLeftAxis>
	<style>
		<defaultStyles>
			<defaultStyle refStyle="ch"/>
		</defaultStyles>
		<CSS value="width:500px;height:255px;border:1pt solid silver"/></style>
	<noDataHandler>
		<contents>
			<block>
				<contents>
					<textItem>
						<dataSource>
							<staticValue>No Data Available</staticValue>
						</dataSource>
						<style>
							<CSS value="padding:10px 18px;"/>
						</style>
					</textItem>
				</contents>
			</block>
		</contents>
	</noDataHandler>
	<v2_legend>
		<v2_legendPosition>
			<v2_legendPreset legendPositionPreset="bottom"/>
		</v2_legendPosition>
		<style>
			<defaultStyles>
				<defaultStyle refStyle="lg"/>
			</defaultStyles>
		</style>
	</v2_legend>
	<v2_chartTitle refQuery="Top Performance"><style><defaultStyles><defaultStyle refStyle="ct"/></defaultStyles><CSS value="text-align:left;color:gray;font-size:10pt"/></style><v2_chartTextItems><v2_chartTextItem><dataSource><staticValue>Top Perform Volumes</staticValue></dataSource></v2_chartTextItem></v2_chartTextItems></v2_chartTitle></v2_combinationChart></contents><style><CSS value="padding-top:5px"/></style></tableCell></tableCells></tableRow><tableRow><tableCells><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents><style><CSS value="padding-left:10px;vertical-align:top"/></style></tableCell><tableCell><contents/></tableCell></tableCells></tableRow></tableRows></table></contents>
								</pageBody>
								
								<pageFooter>
									<contents>
										
									<table>
                                            <tableRows>
                                                <tableRow>
                                                    <tableCells>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <image>
            <dataSource>
                <staticValue>../sanscreen/images/netapp_logo.png</staticValue>
            </dataSource>
        <style><CSS value="width:90px;height:36px"/></style></image></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:left;width:30%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                <textItem><dataSource><staticValue>Page </staticValue></dataSource></textItem><pageNumber/>
                                                            </contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:center;color:#9EA2A2;font-family:Helvetica;font-size:12px;width:40%"/>
                                                            </style>
                                                        </tableCell>
                                                        <tableCell>
                                                            <contents>
                                                                
                                                            <textItem><dataSource><staticValue>OnCommand Insight 7.3.  2014-18 NetApp.</staticValue></dataSource><style><CSS value="font-weight:normal"/></style></textItem></contents>
                                                            <style>
                                                                <CSS value="vertical-align:middle;text-align:right;width:30%;color:#9EA2A2;font-family:Arial;font-size:12px"/>
                                                            </style>
                                                        </tableCell>
                                                    </tableCells>
                                                </tableRow>
                                            </tableRows>
                                            <style>
                                                <defaultStyles>
                                                    <defaultStyle refStyle="tb"/>
                                                </defaultStyles>
                                                <CSS value="border-collapse:collapse;width:100%;height:32px"/>
                                            </style>
                                        </table></contents>
									<style>
										<defaultStyles>
											<defaultStyle refStyle="pf"/>
										</defaultStyles>
										<CSS value="padding-top:10px"/>
									</style>
								</pageFooter>
							</page>
						</reportPages>
					</layout>
				</layouts>
			<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" output="no" value="true"/><XMLAttribute name="listSeparator" output="no" value=","/><XMLAttribute name="RS_modelModificationTime" output="no" value="2017-11-15T20:33:46.811Z"/></XMLAttributes><reportName>3.12 QoS Policy and Status</reportName><classStyles><classStyle name="freezeColumns" label="freezeColumns"/><classStyle name="freezeRows" label="freezeRows"/><classStyle name="freezeCorner" label="freezeCorner"/></classStyles><queries><query name="QoS Policies">
			<source>
				
			<sqlQuery name="SQL1" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
vol.StorageName as 'Storage Name',
SUBSTRING_INDEX(vol.Volume, ':', -1) as 'Volume',
vol.AllocatedGB as 'Allocated GB',
vol.UsedGB as 'Used GB',
pol.QoSPolicy as 'QoS Policy',
pol2.QoSLimitIOPS as 'QoS Limit IOPS',
pol3.qosLimitMBPS as 'QoS Limit MBPS',
perf.TotalIOpS as 'Total IOpS',
perf.PeakIOpS as 'Peak IOpS',
perf.IODensity as 'IOpS/TB',


IF(1-(perf.TotalIOpS / pol2.QoSLimitIOPS)&lt;0, 0, 1-(perf.TotalIOpS / pol2.QoSLimitIOPS)) as '% Available'

FROM
(
SELECT
dwh_inventory.storage.name as 'StorageName',
dwh_inventory.internal_volume.name as 'Volume',
dwh_inventory.internal_volume.totalAllocatedCapacityMB/1024 as 'AllocatedGB',
dwh_inventory.internal_volume.totalUsedCapacityMB/1024 as 'UsedGB',

dwh_inventory.internal_volume.id as volid

FROM dwh_inventory.internal_volume
JOIN  dwh_inventory.storage
ON    dwh_inventory.storage.id=dwh_inventory.internal_volume.storageid

GROUP BY dwh_inventory.internal_volume.id ) vol


JOIN

(
SELECT 
CONCAT( UCASE(LEFT(SUBSTRING_INDEX(dwh_inventory.extended_data.fieldvalue,'_',1),1)), SUBSTRING(SUBSTRING_INDEX(dwh_inventory.extended_data.fieldvalue,'_',1),2) ) as 'QoSPolicy',
dwh_inventory.extended_data.objectid
FROM dwh_inventory.extended_data
WHERE dwh_inventory.extended_data.fieldname = 'qosPolicy' ) pol ON pol.objectid=vol.volid 

LEFT JOIN

(
SELECT 
cast(dwh_inventory.extended_data.fieldvalue as signed) as 'QoSLimitIOPS',
dwh_inventory.extended_data.objectid
FROM dwh_inventory.extended_data
WHERE dwh_inventory.extended_data.fieldname = 'qosLimitIOPS' ) pol2 ON pol2.objectid=vol.volid 


LEFT JOIN

(
SELECT 
dwh_inventory.extended_data.fieldvalue as 'qosLimitMBPS',
dwh_inventory.extended_data.objectid
FROM dwh_inventory.extended_data
WHERE dwh_inventory.extended_data.fieldname = 'qosLimitMBPS' ) pol3 ON pol3.objectid=vol.volid 

LEFT JOIN


/* 2nd ETL SQL 
(
SELECT
dwh_custom.qos_perf.volid as volid,
dwh_custom.qos_perf.totaliops as 'TotalIOpS',
dwh_custom.qos_perf.peakiops as 'PeakIOpS',
dwh_custom.qos_perf.iodensity as 'IODensity'

FROM dwh_custom.qos_perf) perf ON perf.volid=vol.volid
*/


/* Standard SQL - slow in large environments */
(
SELECT 
dwh_performance.internal_volume_dimension.id as volid,
ROUND(AVG(dwh_performance.internal_volume_hourly_performance_fact.totaliops),0) as 'TotalIOPS',
ROUND(MAX(dwh_performance.internal_volume_hourly_performance_fact.totaliopsmax),0) as 'PeakIOPS',
ROUND(AVG(dwh_performance.internal_volume_hourly_performance_fact.totaliodensity),0) as 'IODensity'


FROM dwh_performance.internal_volume_hourly_performance_fact
JOIN  dwh_performance.internal_volume_dimension
ON     dwh_performance.internal_volume_dimension.tk=dwh_performance.internal_volume_hourly_performance_fact.internalvolumetk


GROUP BY dwh_performance.internal_volume_dimension.id ) perf ON perf.volid=vol.volid








</sqlText>
		<mdProjectedItems><mdProjectedItem name="Storage Name"/><mdProjectedItem name="Volume"/><mdProjectedItem name="Allocated GB"/><mdProjectedItem name="Used GB"/><mdProjectedItem name="QoS Policy"/><mdProjectedItem name="QoS Limit IOPS"/><mdProjectedItem name="QoS Limit MBPS"/><mdProjectedItem name="Total IOpS"/><mdProjectedItem name="Peak IOpS"/><mdProjectedItem name="IOpS/TB"/><mdProjectedItem name="% Available"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Storage Name"><expression>[SQL1].[Storage Name]</expression></dataItem><dataItem name="Volume"><expression>[SQL1].[Volume]</expression></dataItem><dataItem name="Allocated GB"><expression>[SQL1].[Allocated GB]</expression></dataItem><dataItem name="Used GB"><expression>[SQL1].[Used GB]</expression></dataItem><dataItem name="QoS Policy"><expression>[SQL1].[QoS Policy]</expression></dataItem><dataItem name="QoS Limit IOPS"><expression>[SQL1].[QoS Limit IOPS]</expression></dataItem><dataItem name="QoS Limit MBPS"><expression>[SQL1].[QoS Limit MBPS]</expression></dataItem><dataItem name="Total IOpS"><expression>[SQL1].[Total IOpS]</expression></dataItem><dataItem name="Peak IOpS"><expression>[SQL1].[Peak IOpS]</expression></dataItem><dataItem name="IOpS/TB"><expression>[SQL1].[IOpS/TB]</expression></dataItem><dataItem name="% Available"><expression>[SQL1].[% Available]</expression></dataItem></selection>
		</query><query name="Top Utilized Volumes">
			<source>
				
			<sqlQuery name="SQL2" dataSource="dwh_inventory" type="passThrough">
			<sqlText>SELECT
vol.Volume as 'Volume',
pol.QoSPolicy as 'QoS Policy',
pol2.QoSLimitIOPS as 'QoS Limit IOPS',
pol3.qosLimitMBPS as 'QoS Limit MBPS',
perf.TotalIOpS as 'Total IOpS',
perf.PeakIOpS as 'Peak IOpS',

IF(1-(perf.TotalIOpS / pol2.QoSLimitIOPS)&lt;0, 0, 1-(perf.TotalIOpS / pol2.QoSLimitIOPS)) as '% Available'

FROM
(
SELECT
dwh_inventory.internal_volume.name as 'Volume',
dwh_inventory.internal_volume.id as volid

FROM dwh_inventory.internal_volume

GROUP BY dwh_inventory.internal_volume.id ) vol

JOIN

(
SELECT 
CONCAT( UCASE(LEFT(SUBSTRING_INDEX(dwh_inventory.extended_data.fieldvalue,'_',1),1)), SUBSTRING(SUBSTRING_INDEX(dwh_inventory.extended_data.fieldvalue,'_',1),2) ) as 'QoSPolicy',
dwh_inventory.extended_data.objectid
FROM dwh_inventory.extended_data
WHERE dwh_inventory.extended_data.fieldname = 'qosPolicy' ) pol ON pol.objectid=vol.volid 

LEFT JOIN

(
SELECT 
cast(dwh_inventory.extended_data.fieldvalue as signed) as 'QoSLimitIOPS',
dwh_inventory.extended_data.objectid
FROM dwh_inventory.extended_data
WHERE dwh_inventory.extended_data.fieldname = 'qosLimitIOPS' ) pol2 ON pol2.objectid=vol.volid 


LEFT JOIN

(
SELECT 
dwh_inventory.extended_data.fieldvalue as 'qosLimitMBPS',
dwh_inventory.extended_data.objectid
FROM dwh_inventory.extended_data
WHERE dwh_inventory.extended_data.fieldname = 'qosLimitMBPS' ) pol3 ON pol3.objectid=vol.volid 

LEFT JOIN


/* 2nd ETL SQL 
(
SELECT
dwh_custom.qos_perf.volid as volid,
dwh_custom.qos_perf.totaliops as 'TotalIOpS',
dwh_custom.qos_perf.peakiops as 'PeakIOpS',
dwh_custom.qos_perf.iodensity as 'IODensity'

FROM dwh_custom.qos_perf) perf ON perf.volid=vol.volid
*/


/* Standard SQL - slow in large environments */
(
SELECT 
dwh_performance.internal_volume_dimension.id as volid,
ROUND(AVG(dwh_performance.internal_volume_hourly_performance_fact.totaliops),0) as 'TotalIOPS',
ROUND(MAX(dwh_performance.internal_volume_hourly_performance_fact.totaliopsmax),0) as 'PeakIOPS',
ROUND(AVG(dwh_performance.internal_volume_hourly_performance_fact.totaliodensity),0) as 'IODensity'


FROM dwh_performance.internal_volume_hourly_performance_fact
JOIN  dwh_performance.internal_volume_dimension
ON     dwh_performance.internal_volume_dimension.tk=dwh_performance.internal_volume_hourly_performance_fact.internalvolumetk


GROUP BY dwh_performance.internal_volume_dimension.id ) perf ON perf.volid=vol.volid






</sqlText>
		<mdProjectedItems><mdProjectedItem name="Volume"/><mdProjectedItem name="QoS Policy"/><mdProjectedItem name="QoS Limit IOPS"/><mdProjectedItem name="QoS Limit MBPS"/><mdProjectedItem name="Total IOpS"/><mdProjectedItem name="Peak IOpS"/><mdProjectedItem name="% Available"/></mdProjectedItems></sqlQuery></source>
			<selection><dataItem name="Volume"><expression>[SQL2].[Volume]</expression></dataItem><dataItem name="QoS Policy"><expression>[SQL2].[QoS Policy]</expression></dataItem><dataItem name="QoS Limit IOPS" rollupAggregate="maximum"><expression>[SQL2].[QoS Limit IOPS]</expression></dataItem><dataItem name="QoS Limit MBPS"><expression>[SQL2].[QoS Limit MBPS]</expression></dataItem><dataItem name="Total IOpS" rollupAggregate="total"><expression>[SQL2].[Total IOpS]</expression></dataItem><dataItem name="Peak IOpS"><expression>[SQL2].[Peak IOpS]</expression></dataItem><dataItem name="% Available" sort="ascending" aggregate="total"><expression>[SQL2].[% Available]</expression></dataItem></selection>
		<detailFilters><detailFilter postAutoAggregation="true"><filterExpression>running-count([% Available]) &lt; 11</filterExpression></detailFilter></detailFilters></query><query name="Top Extreme">
			<source>
				
			<queryRef refQuery="QoS Policies"/></source>
			<selection><dataItem name="Volume"><expression>[QoS Policies].[Volume]</expression></dataItem><dataItem name="QoS Policy"><expression>[QoS Policies].[QoS Policy]</expression></dataItem><dataItem name="QoS Limit IOPS" rollupAggregate="maximum"><expression>[QoS Policies].[QoS Limit IOPS]</expression></dataItem><dataItem name="QoS Limit MBPS"><expression>[QoS Policies].[QoS Limit MBPS]</expression></dataItem><dataItem name="Total IOpS" rollupAggregate="total"><expression>[QoS Policies].[Total IOpS]</expression></dataItem><dataItem name="Peak IOpS"><expression>[SQL3].[Peak IOpS]</expression></dataItem><dataItem name="% Available" sort="ascending"><expression>[QoS Policies].[% Available]</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[QoS Policy]='Extreme'</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>running-count([% Available]) &lt; 6</filterExpression></detailFilter></detailFilters></query><query name="Top High Write">
			<source>
				
			<queryRef refQuery="QoS Policies"/></source>
			<selection><dataItem name="Volume"><expression>[QoS Policies].[Volume]</expression></dataItem><dataItem name="QoS Policy"><expression>[QoS Policies].[QoS Policy]</expression></dataItem><dataItem name="QoS Limit IOPS" rollupAggregate="maximum"><expression>[QoS Policies].[QoS Limit IOPS]</expression></dataItem><dataItem name="QoS Limit MBPS"><expression>[QoS Policies].[QoS Limit MBPS]</expression></dataItem><dataItem name="Total IOpS" rollupAggregate="total"><expression>[QoS Policies].[Total IOpS]</expression></dataItem><dataItem name="Peak IOpS"><expression>[QoS Policies].[Peak IOpS]</expression></dataItem><dataItem name="% Available" sort="ascending"><expression>[QoS Policies].[% Available]</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[QoS Policy]='Highwrite'</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>running-count([% Available]) &lt; 6</filterExpression></detailFilter></detailFilters></query><query name="Top Performance">
			<source>
				
			<queryRef refQuery="QoS Policies"/></source>
			<selection><dataItem name="Volume"><expression>[QoS Policies].[Volume]</expression></dataItem><dataItem name="QoS Policy"><expression>[QoS Policies].[QoS Policy]</expression></dataItem><dataItem name="QoS Limit IOPS" rollupAggregate="maximum"><expression>[QoS Policies].[QoS Limit IOPS]</expression></dataItem><dataItem name="QoS Limit MBPS"><expression>[QoS Policies].[QoS Limit MBPS]</expression></dataItem><dataItem name="Total IOpS" rollupAggregate="total"><expression>[QoS Policies].[Total IOpS]</expression></dataItem><dataItem name="Peak IOpS"><expression>[QoS Policies].[Peak IOpS]</expression></dataItem><dataItem name="% Available" sort="ascending"><expression>[QoS Policies].[% Available]</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[QoS Policy]='Perform'</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>running-count([% Available]) &lt; 6</filterExpression></detailFilter></detailFilters></query><query name="Top Value">
			<source>
				
			<queryRef refQuery="QoS Policies"/></source>
			<selection><dataItem name="Volume"><expression>[SQL6].[Volume]</expression></dataItem><dataItem name="QoS Policy"><expression>[SQL6].[QoS Policy]</expression></dataItem><dataItem name="QoS Limit IOPS"><expression>[SQL6].[QoS Limit IOPS]</expression></dataItem><dataItem name="QoS Limit MBPS"><expression>[SQL6].[QoS Limit MBPS]</expression></dataItem><dataItem name="Total IOpS"><expression>[SQL6].[Total IOpS]</expression></dataItem><dataItem name="Peak IOpS"><expression>[SQL6].[Peak IOpS]</expression></dataItem><dataItem name="% Available" sort="ascending"><expression>[SQL6].[% Available]</expression></dataItem></selection>
		<detailFilters><detailFilter><filterExpression>[QoS Policy]='Value'</filterExpression></detailFilter><detailFilter postAutoAggregation="true"><filterExpression>running-count([% Available]) &lt; 11</filterExpression></detailFilter></detailFilters></query></queries></report>